{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Form","Example","EcoRegions & Stream Temp-County"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Form","index":0,"n_rows":45,"n_cols":13,"rows_kept":45,"merged":[[0,1,1,2],[0,3,0,8],[0,9,1,10],[1,3,1,8],[2,1,2,10],[3,1,3,5],[3,6,3,10],[4,1,4,2],[4,3,4,5],[4,6,4,7],[4,8,4,10],[5,1,5,2],[5,3,5,5],[5,6,5,7],[5,8,5,10],[6,1,6,2],[6,3,6,5],[6,6,6,7],[6,8,6,10],[7,1,7,2],[7,3,7,5],[7,6,7,7],[7,8,7,10],[8,1,8,2],[8,3,8,5],[8,6,8,7],[8,8,8,10],[9,1,9,2],[9,3,9,5],[9,6,9,7],[9,8,9,10],[10,1,10,2],[10,3,10,5],[10,6,10,7],[10,8,10,10],[11,1,11,2],[11,3,11,5],[11,6,11,7],[11,8,11,10],[12,1,12,2],[12,3,12,5],[12,6,12,7],[12,8,12,10],[14,1,14,10],[15,1,15,4],[15,5,15,10],[16,1,16,4],[16,5,16,10],[17,1,17,4],[17,5,17,10],[18,1,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[19,1,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[20,1,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[21,1,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[22,1,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[23,1,26,3],[23,5,23,6],[23,7,23,8],[23,9,23,10],[24,5,24,6],[24,7,24,8],[24,9,24,10],[25,5,25,6],[25,7,25,8],[25,9,25,10],[26,5,26,6],[26,7,26,8],[26,9,26,10],[27,1,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[28,1,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[29,1,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[30,1,31,2],[30,3,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[33,1,33,10],[34,1,34,4],[34,5,34,10],[35,1,35,4],[35,5,35,10],[36,1,36,4],[36,5,36,10],[37,1,37,10],[39,2,39,4],[39,6,39,10],[40,1,40,5],[44,8,44,9]]}
[{"$nulls":3},"MITIGATION REQUEST FORM"]
[{"$nulls":3},"(NCDOT)"]
[]
[null,"NCDOT CONTACT INFORMATION",{"$nulls":4},"REGULATORY CONTACT INFORMATION"]
[null,"Agency/Division",null,"NCDOT/Highways",null,null,"USACE Office",null,"Regulatory Field Office"]
[null,"Branch",{"$nulls":4},"USACE Contact",null,"Monte Matthews"]
[null,"Mailing Address",{"$nulls":4},"Mailing Address",null,"3331 Heritage Trade Drive, Ste 105"]
[null,"City, State, Zip",{"$nulls":4},"City, State, Zip",null,"Wake Forest, NC 27587-4346"]
[null,"Project Manager",{"$nulls":4},"USACE Fax Number",null,"(919) 562-0421"]
[null,"Telephone Number",{"$nulls":4},"NCDWR Contact",null,"Amy Chapman"]
[null,"E-Mail Address",{"$nulls":4},"Mailing Address",null,"1650 Mail Service Center"]
[null,"Supervisor",{"$nulls":4},"City, State, Zip",null,"Raleigh, NC 27699-1650"]
[null,"Telephone Number",{"$nulls":4},"NCDWR Fax Number",null,"(919) 807-6494"]
[]
[null,"PROJECT LOCATION INFORMATION AND IMPACTS"]
[null,"TIP Number(s)"]
[null,"TIP Description"]
[null,"Current Let Date"]
[null,"NCDOT Highway Division"]
[null,"County(ies)"]
[null,"DMS Ecoregion(s)",{"$nulls":10},"Click Tab Below for Eco Regions"]
[null,"River Basin(s)"]
[null,"Cataloging Unit(s) (8-digit)",{"$nulls":10},"Click here for cataloging unit"]
[null,"Total Stream (feet)",null,null,"Warm"]
[{"$nulls":4},"Cool"]
[{"$nulls":4},"Cold"]
[{"$nulls":4},"TOTAL"]
[null,"Total Riparian Wetland Impact (acres)"]
[null,"Total Non-Riparian Wetland Impact (acres)"]
[null,"Total Coastal Marsh Impact (acres)"]
[null,"Total Buffer Impact",null,"Zone 1 (square feet)"]
[{"$nulls":3},"Zone 2 (square feet)"]
[]
[null,"OTHER INFORMATION"]
[null,"USACE Action ID Number (if known)"]
[null,"NCDWR Project Number (if known)"]
[null,"NCDCM Project Number (if known)"]
[null,"Comments:"]
[]
[null,null,"IMPORTANT",{"$nulls":3},"Signature of Applicant or Agent:"]
[null,"Check below if this request is a:"]
[]
[null,null,"New Mitigation Request"]
[]
[null,null,"Revision to a current acceptance",{"$nulls":4},"Date:"]

{"sheet":"Example","index":1,"n_rows":46,"n_cols":12,"rows_kept":46,"merged":[[0,0,2,1],[0,2,0,7],[0,8,2,9],[1,2,1,7],[2,2,2,7],[3,0,3,9],[4,0,4,4],[4,5,4,9],[5,0,5,1],[5,2,5,4],[5,5,5,6],[5,7,5,9],[6,0,6,1],[6,2,6,4],[6,5,6,6],[6,7,6,9],[7,0,7,1],[7,2,7,4],[7,5,7,6],[7,7,7,9],[8,0,8,1],[8,2,8,4],[8,5,8,6],[8,7,8,9],[9,0,9,1],[9,2,9,4],[9,5,9,6],[9,7,9,9],[10,0,10,1],[10,2,10,4],[10,5,10,6],[10,7,10,9],[11,0,11,1],[11,2,11,4],[11,5,11,6],[11,7,11,9],[12,0,12,1],[12,2,12,4],[12,5,12,6],[12,7,12,9],[13,0,13,1],[13,2,13,4],[13,5,13,6],[13,7,13,9],[15,0,15,9],[16,0,16,3],[16,4,16,9],[17,0,17,3],[17,4,17,9],[18,0,18,3],[18,4,18,9],[19,0,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,9],[20,0,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,9],[21,0,21,3],[21,4,21,5],[21,6,21,7],[21,8,21,9],[22,0,22,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[23,0,23,3],[23,4,23,5],[23,6,23,7],[23,8,23,9],[24,0,27,2],[24,4,24,5],[24,6,24,7],[24,8,24,9],[25,4,25,5],[25,6,25,7],[25,8,25,9],[26,4,26,5],[26,6,26,7],[26,8,26,9],[27,4,27,5],[27,6,27,7],[27,8,27,9],[28,0,28,3],[28,4,28,5],[28,6,28,7],[28,8,28,9],[29,0,29,3],[29,4,29,5],[29,6,29,7],[29,8,29,9],[30,0,30,3],[30,4,30,5],[30,6,30,7],[30,8,30,9],[31,0,32,1],[31,2,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[32,2,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[34,0,34,9],[35,0,35,3],[35,4,35,9],[36,0,36,3],[36,4,36,9],[37,0,37,3],[37,4,37,9],[38,0,38,9],[40,1,40,3],[40,5,40,9],[41,0,41,4],[45,7,45,8]]}
[null,null,"MITIGATION REQUEST FORM"]
[null,null,"(NCDOT)"]
[]
[]
["NCDOT CONTACT INFORMATION",{"$nulls":4},"REGULATORY CONTACT INFORMATION"]
["Agency/Division",null,"NCDOT-Highways",null,null,"USACE Office",null,"Regulatory Field Office"]
["Branch",null,"EAU - ECAP",null,null,"USACE Contact",null,"Monte Matthews"]
["Mailing Address",null,"1598 Mail Service Center",null,null,"Mailing Address",null,"3331 Heritage Trade Drive, Ste 105"]
["City, State, Zip",null,"Raleigh, NC 27699-1598",null,null,"City, State, Zip",null,"Wake Forest, NC 27587-4346"]
["Project Manager",{"$nulls":4},"USACE Fax Number",null,"(919) 562-0421"]
["Telephone Number",null,"919-867-5309",null,null,"NCDWR Contact",null,"Amy Chapman"]
["E-Mail Address",null,"youremail@ncdot.gov",null,null,"Mailing Address",null,"1650 Mail Service Center"]
["Supervisor",{"$nulls":4},"City, State, Zip",null,"Raleigh, NC 27699-1650"]
["Telephone Number",{"$nulls":4},"NCDWR Fax Number",null,"(919) 807-6494"]
[]
["PROJECT LOCATION INFORMATION AND IMPACTS"]
["TIP Number(s)",{"$nulls":3},"R-2206 B/C"]
["TIP Description",{"$nulls":3},"Relocation of NC 16 from north of NC 73 to SR 1895 at existing NC 16."]
["Current Let Date",{"$nulls":3},"2022-09-15"]
["NCDOT Highway Division",{"$nulls":3},12,null,12]
["County(ies)",{"$nulls":3},"Catawba",null,"Catawba"]
["EEP Ecoregion(s)",{"$nulls":3},"CP",null,"SP",{"$nulls":4},"Click Tab Below for Eco Regions"]
["River Basin(s)",{"$nulls":3},"Catawba",null,"Catawba"]
["Cataloging Unit(s) (8-digit)",{"$nulls":3},"03050101",null,"03050101",{"$nulls":4},"Click here for cataloging unit"]
["Total Stream (feet)",null,null,"Warm",{"v":1939,"d":"1,939"},null,{"v":11381,"d":"11,381"}]
[{"$nulls":3},"Cool"]
[{"$nulls":3},"Cold"]
[{"$nulls":3},"TOTAL",{"v":1939,"d":"1,939"},null,{"v":11381,"d":"11,381"}]
["Total Riparian Wetland Impact (acres)",{"$nulls":3},0.593,null,3.405]
["Total Non-Riparian Wetland Impact (acres)",{"$nulls":3},1.866,null,0.355]
["Total Coastal Marsh Impact (acres)"]
["Total Buffer Impact",null,"Zone 1 (square feet)"]
[null,null,"Zone 2 (square feet)"]
[]
["OTHER INFORMATION"]
["USACE Action ID Number (if known)",{"$nulls":3},"2004-31320"]
["NCDWR Project Number (if known)",{"$nulls":3},3476]
["NCDCM Project Number (if known)"]
["Comments:"]
[]
[null,"IMPORTANT",{"$nulls":3},"Signature of Applicant or Agent:"]
["Check below if this request is a:"]
[]
[null,"New Mitigation Request"]
[]
[null,"Revision to a current acceptance",{"$nulls":4},"Date:"]

{"sheet":"EcoRegions & Stream Temp-County","index":2,"n_rows":53,"n_cols":8,"rows_kept":53,"merged":[[1,1,1,7]]}
[]
[null,"EcoRegions and Stream Temperatures by County"]
[null,"County","Eco Region","Contains Streams with Temperature Ratings of ",null,"County","Eco Region","Contains Streams with Temperature Ratings of "]
[null,"Alamance","Central Piedmont","Warm",null,"Johnson","Northern Inner Coastal Plain","Warm"]
[null,"Alexander","Central Piedmont","Warm",null,"Jones","Southern Outer Coastal Plain","Warm"]
[null,"Alleghany","Northern Mountains","Cold Cool",null,"Lee","Southern Piedmont","Warm"]
[null,"Anson","Southern Piedmont","Warm",null,"Lenior","Southern Inner Coastal Plain","Warm"]
[null,"Ashe","Northern Mountains","Cold Cool",null,"Lincoln","Southern Piedmont","Cool Warm"]
[null,"Avery","Northern Mountains","Cold Cool",null,"Macon","Southern Mountains","Cold Cool"]
[null,"Beaufort","Northern Outer Coastal Plain","Warm",null,"Madison","Northern Mountains","Cold Cool"]
[null,"Bertie","Northern Outer Coastal Plain","Warm",null,"Martin","Northern Inner Coastal Plain","Warm"]
[null,"Bladen","Southern Inner Coastal Plain","Warm",null,"McDowell","Northern Mountains","Cold Cool Warm"]
[null,"Brunswick","Southern Outer Coastal Plain","Warm",null,"Mecklenburg","Southern Piedmont","Warm"]
[null,"Buncombe","Southern Mountains","Cold Cool",null,"Mitchell","Northern Mountains","Cold Cool"]
[null,"Burke","Northern Mountains","Cold Cool Warm",null,"Montgomery","Southern Piedmont","Warm"]
[null,"Cabarrus","Southern Piedmont","Warm",null,"Moore","Southern Piedmont","Warm"]
[null,"Caldwell","Northern Mountains","Cold Cool Warm",null,"Nash","Northern Inner Coastal Plain","Warm"]
[null,"Camden","Northern Outer Coastal Plain","Warm",null,"New Hanover","Southern Outer Coastal Plain","Warm"]
[null,"Carteret","Southern Outer Coastal Plain","Warm",null,"Northampton","Northern Inner Coastal Plain","Warm"]
[null,"Caswell","Central Piedmont","Warm",null,"Onslow","Southern Outer Coastal Plain","Warm"]
[null,"Catawba","Central Piedmont","Cool Warm",null,"Orange","Central Piedmont","Warm"]
[null,"Chatham","Central Piedmont","Warm",null,"Pamlico","Southern Outer Coastal Plain","Warm"]
[null,"Cherokee","Southern Piedmont","Cold Cool",null,"Pasquotank","Northern Outer Coastal Plain","Warm"]
[null,"Chowan","Northern Outer Coastal Plain","Warm",null,"Pender","Southern Outer Coastal Plain","Warm"]
[null,"Clay","Southern Mountains","Cool Cold",null,"Perquimans","Northern Outer Coastal Plain","Warm"]
[null,"Cleveland","Southern Piedmont","Cold Cool Warm",null,"Person","Central Piedmont","Warm"]
[null,"Columbus","Southern Inner Coastal Plain","Cold Cool Warm",null,"Pitt","Northern Inner Coastal Plain","Warm"]
[null,"Craven","Southern Outer Coastal Plain","Warm",null,"Polk","Southern Piedmont","Cold Cool"]
[null,"Cumberland","Southern Inner Coastal Plain","Warm",null,"Randolph","Central Piedmont","Warm"]
[null,"Currituck","Northern Outer Coastal Plain","Warm",null,"Richmond","Southern Piedmont","Warm"]
[null,"Dare","Northern Outer Coastal Plain","Warm",null,"Robeson","Southern Inner Coastal Plain","Warm"]
[null,"Davidson","Central Piedmont","Warm",null,"Rockingham","Central Piedmont","Warm"]
[null,"Davie","Central Piedmont","Warm",null,"Rowan","Central Piedmont","Warm"]
[null,"Duplin","Southern Inner Coastal Plain","Warm",null,"Rutherford","Southern Piedmont","Cold Cool Warm"]
[null,"Durham","Central Piedmont","Warm",null,"Sampson","Southern Inner Coastal Plain","Warm"]
[null,"Edgecombe","Northern Inner Coastal Plain","Warm",null,"Scotland","Southern Inner Coastal Plain","Warm"]
[null,"Forsyth","Central Piedmont","Warm",null,"Stanly","Southern Piedmont","Warm"]
[null,"Franklin","Central Piedmont","Warm",null,"Stokes","Central Piedmont","Cold Cool Warm"]
[null,"Gaston","Southern Piedmont","Warm",null,"Surry","Central Piedmont","Cold Cool Warm"]
[null,"Gates","Northern Outer Coastal Plain","Warm",null,"Swain","Southern Mountains","Cold Cool"]
[null,"Graham","Southern Mountains","Cold Cool",null,"Transylvania","Southern Mountains","Cold Cool"]
[null,"Granville","Central Piedmont","Warm",null,"Tyrrell","Northern Outer Coastal Plain","Warm"]
[null,"Greene","Northern Inner Coastal Plain","Warm",null,"Union","Southern Piedmont","Warm"]
[null,"Guilford","Central Piedmont","Warm",null,"Vance","Central Piedmont","Warm"]
[null,"Halifax","Northern Inner Coastal Plain","Warm",null,"Wake","Central Piedmont","Warm"]
[null,"Harnett","Southern Inner Coastal Plain","Warm",null,"Warren","Central Piedmont","Wam"]
[null,"Haywood","Southern Mountains","Cold Cool",null,"Washington","Northern Outer Coastal Plain","Warm"]
[null,"Henderson","Southern Mountains","Cold Cool",null,"Watauga","Northern Mountains","Cold Cool"]
[null,"Hertford","Northern Outer Coastal Plain","Warm",null,"Wayne","Northern Inner Coastal Plain","Warm"]
[null,"Hoke","Southern Inner Coastal Plain","Warm",null,"Wilkes","Northern Mountains","Cold Cool Warm"]
[null,"Hyde","Northern Outer Coastal Plain","Warm",null,"Wilson","Northern Inner Coastal Plain","Warm"]
[null,"Iredell","Central Piedmont","Warm",null,"Yadkin","Central Piedmont","Cool Warm"]
[null,"Jackson","Southern Mountains","Cold Cool",null,"Yancy","Northern Mountains","Cold Cool"]